from common.mysql.MySQLhelper import get_sql_helper

sqlhelper = get_sql_helper()

def insert_assign_person_base_value(today, id, user_id, nick_name):
    sqlhelper.insert_one(
        "INSERT INTO shequn_wechat_assign (id, create_time, update_time, user_name, user_id) VALUES(%s, %s, %s, %s, %s); ",
        (
        id, today, today, nick_name, user_id))


def delete_assign_person_by_user_id(user_id):
    sqlhelper.delete("DELETE from shequn_wechat_assign where user_id = %s", (user_id))
